The Sr. Data Solutions Engineer role will aid in the development of a new cloud environment by assisting the NCDIT DMV Modernization Team with the design, management, and maintenance of data flow as it pertains to cloud technology. Additionally, this role will also be responsible for data analysis, data profiling, data cleansing, data governance, in preparation for data conversion of the existing environment. The ideal candidate will be able to develop & maintain cloud data strategy, evaluate data elements and structure, and ensure the smooth integration of data internal and external to cloud initiatives. This position will direct a team two database programmers to complete the data analysis. Additionally, the position will assist in a leadership role:
·Execution of cloud design and implementation strategies.
·Evaluation and selection of the appropriate data frameworks.
·Establishment of standards, best practices for data conversion, data mapping, data cleansing, and data migration as it evolves from legacy to cloud-based technologies.
·Design of system integration containing database permissions, keys, and access for authorized data usage and reporting.
·Process Instruction of infrastructure movement techniques and data transfers using multiple ETL/ELT sources.
·Responding to technical issues timely and effectively.
· Leading and solicit database programmers, application teams, security, and infrastructure teams to monitor cloud privacy, performance, and load.
· Capturing lessons learned and transitional knowledge to assist the Leadership Team in establishing a mentoring path that provides technical exposure and develops the next generation of DIT leaders and technical staff.
The Sr. Data Solutions Engineer position will also serve in a lead role in the application support team’s quality assurance for operations and maintenance initiatives. The resource will serve as Subject Matter Expert (SME) with the following expected responsibilities:
| Skill | Required /Desired | Amount | of Experience |
|---|---|---|---|
| Database Design | Required | 10 | Years |
| SQL Server, DB2 experience. | Required | 10 | Years |
| Database back up, maintaining table partitions | Required | 5 | Years |
| Database Conversion, Cleansing, Migration | Required | 10 | Years |
| Application development or application support or application testing or a combination of those experiences. | Required | 10 | Years |
| Software development lifecycle methodologies | Required | 10 | Years |
| Ability to create and maintain required documentation. This includes documenting customer requirements, design flows and systems flow. | Required | 10 | Years |
| Leading or Supervising an IT Team | Required | 5 | Years |
| Written and verbal communications are clear, concise and achieve intended objectives | Required | 10 | Years |
| Problem Diagnosis skills [i.e., discovery, replication, troubleshooting, resolution, verification, communication and/or escalation as required] | Required | 10 | Years |
| Experience with writing test cases, executing those cases and leading technical training | Required | 10 | Years |
| BS/BA degree in Computer Science, Information Technology, Computer Engineering; MS degree in Computer Science or equivalent or an MBA | Required | 5 | Years |
| MS Azure or MS Cloud certification | Highly desired | 2 | Years |
| SQL Server SSIS management and/or framework | Highly desired | 2 | Years |
| Parquet text maintenance knowledge | Nice to have | 2 | Years |
| Must reside in North Carolina and can report on-site at short notice | Required | 0 |
| No. | Question |
|---|---|
| Question1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you agree to this requirement? |
| Question2 | What is your candidate's email address? |
| Question3 | How soon can your candidate start if selected for this opportunity? |
| Question4 | Vendors are encouraged to submit candidates that are available for the duration of the assignment. Do you anticipate your candidate being able to work until the proposed end date listed on this VectorVMS req? |
| Question5 | Vendors must disclose to the agency if the candidate will be subcontracted at the time of submission. Is your candidate an employee of your company or a subcontractor? Please be sure to notify a CAI Account Manager if your candidate's employee status changes. |
| Question6 | Vendors must notify the agency if any portion of the requirements listed in this task order will be outsourced to other countries. Do you anticipate outsourcing any work being done for this assignment to another country? |
| Question7 | Candidates submitted above the hourly Vendor Rate of - may not be considered for this assignment. Do you agree to this requirement? |
| Question8 | This is a hybrid position. The candidate will be required onsite 2-3 days a week. Do you accept this requirement? |